Gail Shaw wrote:
> It's called the clustered index.

That's funky. Every time I ask an expert what a "clustered index" is, I 
get a different definition. And I don't think they're compatible but 
differing descriptions of the same concept.

I'd been told a clustered index is one in which the rows in the table 
date are in physically the same order as the rows in the index. And that 
that's why you can only have one clustered index for a table.

-- 
Darren New / San Diego, CA, USA (PST)

Post a reply to this message